DBC-Zorgproducten per jaar, specialisme, diagnose

Dataset statistics

Number of variables	14
Number of observations	318344
Missing cells	48907
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	34.0 MiB
Average record size in memory	112.0 B

Variable types

Categorical	4
DateTime	1
Numeric	9

Alerts

`VERSIE` has constant value "1.0"	Constant
`DATUM_BESTAND` has constant value "2022-12-05"	Constant
`PEILDATUM` has constant value "2022-12-01"	Constant
`TYPERENDE_DIAGNOSE_CD` has a high cardinality: 1896 distinct values	High cardinality
`BEHANDELEND_SPECIALISME_CD` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`AANTAL_PAT_PER_ZPD` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_ZPD`	High correlation
`AANTAL_SUBTRAJECT_PER_ZPD` is highly overall correlated with `AANTAL_PAT_PER_ZPD`	High correlation
`AANTAL_PAT_PER_DIAG` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_DIAG`	High correlation
`AANTAL_SUBTRAJECT_PER_DIAG` is highly overall correlated with `AANTAL_PAT_PER_DIAG`	High correlation
`AANTAL_PAT_PER_SPC` is highly overall correlated with `BEHANDELEND_SPECIALISME_CD` and 1 other fields	High correlation
`AANTAL_SUBTRAJECT_PER_SPC` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`GEMIDDELDE_VERKOOPPRIJS` has 48907 (15.4%) missing values	Missing
`AANTAL_SUBTRAJECT_PER_ZPD` is highly skewed (γ1 = 21.34161442)	Skewed

Reproduction

Analysis started	2022-12-21 10:29:50.867882
Analysis finished	2022-12-21 10:30:08.561565
Duration	17.69 seconds
Software version	pandas-profiling vdev
Download configuration	config.json

VERSIE
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

1.0	318344

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	955032
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	318344	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	318344	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	318344	33.3%
.	318344	33.3%
0	318344	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	636688	66.7%
Other Punctuation	318344	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	318344	50.0%
0	318344	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	318344	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	955032	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	318344	33.3%
.	318344	33.3%
0	318344	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	955032	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	318344	33.3%
.	318344	33.3%
0	318344	33.3%

DATUM_BESTAND
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

2022-12-05	318344

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3183440
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2022-12-05
2nd row	2022-12-05
3rd row	2022-12-05
4th row	2022-12-05
5th row	2022-12-05

Common Values

Value	Count	Frequency (%)
2022-12-05	318344	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2022-12-05	318344	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	1273376	40.0%
0	636688	20.0%
-	636688	20.0%
1	318344	10.0%
5	318344	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2546752	80.0%
Dash Punctuation	636688	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1273376	50.0%
0	636688	25.0%
1	318344	12.5%
5	318344	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	636688	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3183440	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1273376	40.0%
0	636688	20.0%
-	636688	20.0%
1	318344	10.0%
5	318344	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3183440	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1273376	40.0%
0	636688	20.0%
-	636688	20.0%
1	318344	10.0%
5	318344	10.0%

PEILDATUM
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

2022-12-01	318344

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3183440
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2022-12-01
2nd row	2022-12-01
3rd row	2022-12-01
4th row	2022-12-01
5th row	2022-12-01

Common Values

Value	Count	Frequency (%)
2022-12-01	318344	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2022-12-01	318344	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	1273376	40.0%
0	636688	20.0%
-	636688	20.0%
1	636688	20.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2546752	80.0%
Dash Punctuation	636688	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1273376	50.0%
0	636688	25.0%
1	636688	25.0%

Dash Punctuation

Value	Count	Frequency (%)
-	636688	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3183440	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1273376	40.0%
0	636688	20.0%
-	636688	20.0%
1	636688	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3183440	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1273376	40.0%
0	636688	20.0%
-	636688	20.0%
1	636688	20.0%

JAAR
Date

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

Minimum	2012-01-01 00:00:00
Maximum	2022-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=11)

BEHANDELEND_SPECIALISME_CD
Real number (ℝ)

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	437.52447

Minimum	301
Maximum	8418
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	301
5-th percentile	302
Q1	305
median	313
Q3	322
95-th percentile	335
Maximum	8418
Range	8117
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	986.55887
Coefficient of variation (CV)	2.2548656
Kurtosis	61.329571
Mean	437.52447
Median Absolute Deviation (MAD)	8
Skewness	7.9524024
Sum	1.3928329 × 10⁸
Variance	973298.41
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
305	44956	14.1%
313	41298	13.0%
303	36646	11.5%
330	25213	7.9%
316	21669	6.8%
308	17107	5.4%
306	13347	4.2%
324	13126	4.1%
301	12788	4.0%
304	10357	3.3%
Other values (18)	81837	25.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
301	12788	4.0%
302	6977	2.2%
303	36646	11.5%
304	10357	3.3%
305	44956	14.1%
306	13347	4.2%
307	5560	1.7%
308	17107	5.4%
310	3495	1.1%
313	41298	13.0%

Value	Count	Frequency (%)
8418	4248	1.3%
8416	535	0.2%
1900	210	0.1%
390	862	0.3%
389	3354	1.1%
362	4287	1.3%
361	2285	0.7%
335	3223	1.0%
330	25213	7.9%
329	834	0.3%

TYPERENDE_DIAGNOSE_CD
Categorical

Distinct	1896
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

101	1345
402	1305
403	1274
301	1273
201	1200
Other values (1891)	311947

Length

Max length	4
Median length	3
Mean length	3.3521882
Min length	2

Characters and Unicode

Total characters	1067149
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23 ?
Unique (%)	< 0.1%

Sample

1st row	12
2nd row	15
3rd row	14
4th row	07
5th row	19

Common Values

Value	Count	Frequency (%)
101	1345	0.4%
402	1305	0.4%
403	1274	0.4%
301	1273	0.4%
201	1200	0.4%
203	1191	0.4%
401	1065	0.3%
404	1056	0.3%
802	1037	0.3%
409	1030	0.3%
Other values (1886)	306568	96.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
101	1345	0.4%
402	1305	0.4%
403	1274	0.4%
301	1273	0.4%
201	1200	0.4%
203	1191	0.4%
401	1065	0.3%
404	1056	0.3%
802	1037	0.3%
409	1030	0.3%
Other values (1886)	306568	96.3%

Most occurring characters

Value	Count	Frequency (%)
1	204187	19.1%
0	195580	18.3%
2	141433	13.3%
3	115628	10.8%
5	82324	7.7%
9	76927	7.2%
4	75752	7.1%
7	62814	5.9%
6	55762	5.2%
8	45953	4.3%
Other values (15)	10789	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1056360	99.0%
Uppercase Letter	10789	1.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	2012	18.6%
M	1824	16.9%
B	1295	12.0%
E	910	8.4%
Z	900	8.3%
D	724	6.7%
A	702	6.5%
F	671	6.2%
C	356	3.3%
K	350	3.2%
Other values (5)	1045	9.7%

Decimal Number

Value	Count	Frequency (%)
1	204187	19.3%
0	195580	18.5%
2	141433	13.4%
3	115628	10.9%
5	82324	7.8%
9	76927	7.3%
4	75752	7.2%
7	62814	5.9%
6	55762	5.3%
8	45953	4.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	1056360	99.0%
Latin	10789	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	2012	18.6%
M	1824	16.9%
B	1295	12.0%
E	910	8.4%
Z	900	8.3%
D	724	6.7%
A	702	6.5%
F	671	6.2%
C	356	3.3%
K	350	3.2%
Other values (5)	1045	9.7%

Common

Value	Count	Frequency (%)
1	204187	19.3%
0	195580	18.5%
2	141433	13.4%
3	115628	10.9%
5	82324	7.8%
9	76927	7.3%
4	75752	7.2%
7	62814	5.9%
6	55762	5.3%
8	45953	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1067149	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	204187	19.1%
0	195580	18.3%
2	141433	13.3%
3	115628	10.8%
5	82324	7.7%
9	76927	7.2%
4	75752	7.1%
7	62814	5.9%
6	55762	5.2%
8	45953	4.3%
Other values (15)	10789	1.0%

ZORGPRODUCT_CD
Real number (ℝ)

Distinct	6010
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4158058 × 10⁸

Minimum	10501002
Maximum	9.9841808 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	10501002
5-th percentile	28999038
Q1	99799064
median	1.4959903 × 10⁸
Q3	9.90004 × 10⁸
95-th percentile	9.9051604 × 10⁸
Maximum	9.9841808 × 10⁸
Range	9.8791708 × 10⁸
Interquartile range (IQR)	8.9020494 × 10⁸

Descriptive statistics

Standard deviation	4.291979 × 10⁸
Coefficient of variation (CV)	0.97195827
Kurtosis	-1.7411076
Mean	4.4158058 × 10⁸
Median Absolute Deviation (MAD)	1.1960003 × 10⁸
Skewness	0.46371697
Sum	1.4057453 × 10¹⁴
Variance	1.8421084 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
990004009	2321	0.7%
990004007	2284	0.7%
990003004	2232	0.7%
990004006	1852	0.6%
990356076	1688	0.5%
990356073	1559	0.5%
131999228	1485	0.5%
131999164	1469	0.5%
990003007	1452	0.5%
131999194	1347	0.4%
Other values (6000)	300655	94.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10501002	9	< 0.1%
10501003	11	< 0.1%
10501004	11	< 0.1%
10501005	11	< 0.1%
10501007	3	< 0.1%
10501008	11	< 0.1%
10501010	11	< 0.1%
10501011	3	< 0.1%
11101002	10	< 0.1%
11101003	11	< 0.1%

Value	Count	Frequency (%)
998418081	159	< 0.1%
998418080	143	< 0.1%
998418079	38	< 0.1%
998418077	8	< 0.1%
998418076	8	< 0.1%
998418075	6	< 0.1%
998418074	214	0.1%
998418073	214	0.1%
998418072	8	< 0.1%
998418071	8	< 0.1%

AANTAL_PAT_PER_ZPD
Real number (ℝ)

Distinct	10030
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	513.65484

Minimum	1
Maximum	165142
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	14
Q3	103
95-th percentile	1743
Maximum	165142
Range	165141
Interquartile range (IQR)	100

Descriptive statistics

Standard deviation	3168.7391
Coefficient of variation (CV)	6.1690046
Kurtosis	406.13596
Mean	513.65484
Median Absolute Deviation (MAD)	13
Skewness	16.6881
Sum	1.6351894 × 10⁸
Variance	10040907
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	52487	16.5%
2	25668	8.1%
3	16746	5.3%
4	12323	3.9%
5	9605	3.0%
6	8140	2.6%
7	6746	2.1%
8	5785	1.8%
9	5208	1.6%
10	4686	1.5%
Other values (10020)	170950	53.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	52487	16.5%
2	25668	8.1%
3	16746	5.3%
4	12323	3.9%
5	9605	3.0%
6	8140	2.6%
7	6746	2.1%
8	5785	1.8%
9	5208	1.6%
10	4686	1.5%

Value	Count	Frequency (%)
165142	1	< 0.1%
156428	1	< 0.1%
155884	1	< 0.1%
154269	1	< 0.1%
154183	1	< 0.1%
144724	1	< 0.1%
118395	1	< 0.1%
115938	1	< 0.1%
110520	1	< 0.1%
110215	1	< 0.1%

AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	10771
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	606.43279

Minimum	1
Maximum	239709
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	15
Q3	113
95-th percentile	1989
Maximum	239709
Range	239708
Interquartile range (IQR)	110

Descriptive statistics

Standard deviation	4074.3749
Coefficient of variation (CV)	6.7185927
Kurtosis	725.90388
Mean	606.43279
Median Absolute Deviation (MAD)	14
Skewness	21.341614
Sum	1.9305424 × 10⁸
Variance	16600531
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	50560	15.9%
2	25222	7.9%
3	16585	5.2%
4	12115	3.8%
5	9513	3.0%
6	8130	2.6%
7	6712	2.1%
8	5724	1.8%
9	5150	1.6%
10	4687	1.5%
Other values (10761)	173946	54.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	50560	15.9%
2	25222	7.9%
3	16585	5.2%
4	12115	3.8%
5	9513	3.0%
6	8130	2.6%
7	6712	2.1%
8	5724	1.8%
9	5150	1.6%
10	4687	1.5%

Value	Count	Frequency (%)
239709	1	< 0.1%
232359	1	< 0.1%
231983	1	< 0.1%
230952	1	< 0.1%
227936	1	< 0.1%
227457	1	< 0.1%
225066	1	< 0.1%
223938	1	< 0.1%
218449	1	< 0.1%
215070	1	< 0.1%

AANTAL_PAT_PER_DIAG
Real number (ℝ)

Distinct	8978
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7699.6987

Minimum	1
Maximum	227967
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	41
Q1	409
median	1726
Q3	6384
95-th percentile	36764
Maximum	227967
Range	227966
Interquartile range (IQR)	5975

Descriptive statistics

Standard deviation	17832.563
Coefficient of variation (CV)	2.316008
Kurtosis	34.326001
Mean	7699.6987
Median Absolute Deviation (MAD)	1569
Skewness	5.0724876
Sum	2.4511529 × 10⁹
Variance	3.1800032 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	526	0.2%
8	483	0.2%
25	477	0.1%
9	465	0.1%
19	456	0.1%
12	453	0.1%
26	451	0.1%
22	442	0.1%
17	440	0.1%
30	439	0.1%
Other values (8968)	313712	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	356	0.1%
2	415	0.1%
3	381	0.1%
4	405	0.1%
5	367	0.1%
6	404	0.1%
7	375	0.1%
8	483	0.2%
9	465	0.1%
10	390	0.1%

Value	Count	Frequency (%)
227967	23	< 0.1%
223882	23	< 0.1%
217852	24	< 0.1%
214511	17	< 0.1%
213536	25	< 0.1%
211593	17	< 0.1%
210434	19	< 0.1%
205348	17	< 0.1%
200603	16	< 0.1%
198527	20	< 0.1%

AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)

Distinct	9982
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11077.621

Minimum	1
Maximum	369837
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1
5-th percentile	53
Q1	541
median	2391
Q3	9112
95-th percentile	51816
Maximum	369837
Range	369836
Interquartile range (IQR)	8571

Descriptive statistics

Standard deviation	26570.882
Coefficient of variation (CV)	2.3986091
Kurtosis	38.096034
Mean	11077.621
Median Absolute Deviation (MAD)	2192
Skewness	5.3301954
Sum	3.5264942 × 10⁹
Variance	7.0601178 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11	388	0.1%
23	367	0.1%
17	364	0.1%
52	359	0.1%
31	353	0.1%
44	352	0.1%
40	351	0.1%
6	349	0.1%
13	346	0.1%
5	340	0.1%
Other values (9972)	314775	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	283	0.1%
2	318	0.1%
3	321	0.1%
4	303	0.1%
5	340	0.1%
6	349	0.1%
7	325	0.1%
8	289	0.1%
9	269	0.1%
10	323	0.1%

Value	Count	Frequency (%)
369837	23	< 0.1%
350599	23	< 0.1%
348523	25	< 0.1%
343080	24	< 0.1%
341692	19	< 0.1%
323791	20	< 0.1%
315780	17	< 0.1%
310778	17	< 0.1%
298646	17	< 0.1%
289045	16	< 0.1%

AANTAL_PAT_PER_SPC
Real number (ℝ)

Distinct	297
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	671458.98

Minimum	1462
Maximum	1487642
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1462
5-th percentile	42576
Q1	287339
median	746969
Q3	1026611
95-th percentile	1340835
Maximum	1487642
Range	1486180
Interquartile range (IQR)	739272

Descriptive statistics

Standard deviation	412565.29
Coefficient of variation (CV)	0.61443111
Kurtosis	-1.1119908
Mean	671458.98
Median Absolute Deviation (MAD)	314357
Skewness	0.013732963
Sum	2.1375494 × 10¹¹
Variance	1.7021012 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
880942	5102	1.6%
874120	4354	1.4%
843981	4347	1.4%
894334	4333	1.4%
880497	4273	1.3%
897710	4212	1.3%
764831	4088	1.3%
782530	3999	1.3%
1081437	3890	1.2%
1100537	3866	1.2%
Other values (287)	275880	86.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1462	117	< 0.1%
1610	130	< 0.1%
1702	138	< 0.1%
1920	131	< 0.1%
2265	183	0.1%
2495	173	0.1%
6806	380	0.1%
8770	74	< 0.1%
13002	371	0.1%
13151	461	0.1%

Value	Count	Frequency (%)
1487642	2975	0.9%
1450406	3048	1.0%
1421743	3564	1.1%
1344553	3543	1.1%
1340835	3441	1.1%
1332463	3545	1.1%
1316670	3463	1.1%
1282963	3576	1.1%
1265249	1177	0.4%
1262543	1201	0.4%

AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)

Distinct	296
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1081819.8

Minimum	1665
Maximum	2666159
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	1665
5-th percentile	46598
Q1	435553
median	1066242
Q3	1747056
95-th percentile	2550054
Maximum	2666159
Range	2664494
Interquartile range (IQR)	1311503

Descriptive statistics

Standard deviation	739036.47
Coefficient of variation (CV)	0.68314192
Kurtosis	-0.78515633
Mean	1081819.8
Median Absolute Deviation (MAD)	661913
Skewness	0.37471763
Sum	3.4439085 × 10¹¹
Variance	5.461749 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1211792	5102	1.6%
1281522	4354	1.4%
1216262	4347	1.4%
1315601	4333	1.4%
1300471	4273	1.3%
1341874	4212	1.3%
1155373	4088	1.3%
1167482	3999	1.3%
2550054	3890	1.2%
2666159	3866	1.2%
Other values (286)	275880	86.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1665	117	< 0.1%
1861	130	< 0.1%
1962	138	< 0.1%
2195	131	< 0.1%
2816	173	0.1%
3015	183	0.1%
7385	380	0.1%
9336	74	< 0.1%
14580	371	0.1%
14976	461	0.1%

Value	Count	Frequency (%)
2666159	3866	1.2%
2620452	3787	1.2%
2595374	3844	1.2%
2588468	3790	1.2%
2550054	3890	1.2%
2481772	3851	1.2%
2179576	3757	1.2%
2062293	3810	1.2%
2052295	1168	0.4%
1990240	1167	0.4%

GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)

Distinct	3517
Distinct (%)	1.3%
Missing	48907
Missing (%)	15.4%
Infinite	0
Infinite (%)	0.0%
Mean	3559.3752

Minimum	70
Maximum	287220
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.4 MiB

Quantile statistics

Minimum	70
5-th percentile	140
Q1	475
median	1245
Q3	4145
95-th percentile	13455
Maximum	287220
Range	287150
Interquartile range (IQR)	3670

Descriptive statistics

Standard deviation	6514.5164
Coefficient of variation (CV)	1.8302416
Kurtosis	148.6648
Mean	3559.3752
Median Absolute Deviation (MAD)	1015
Skewness	7.2625721
Sum	9.5902736 × 10⁸
Variance	42438923
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
160	2019	0.6%
105	1920	0.6%
110	1790	0.6%
180	1572	0.5%
185	1486	0.5%
300	1379	0.4%
175	1373	0.4%
120	1364	0.4%
145	1359	0.4%
125	1243	0.4%
Other values (3507)	253932	79.8%
(Missing)	48907	15.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
70	226	0.1%
75	75	< 0.1%
80	362	0.1%
85	919	0.3%
90	672	0.2%
95	713	0.2%
100	922	0.3%
105	1920	0.6%
110	1790	0.6%
115	1046	0.3%

Value	Count	Frequency (%)
287220	8	< 0.1%
148910	3	< 0.1%
142835	4	< 0.1%
122155	4	< 0.1%
116765	3	< 0.1%
109725	7	< 0.1%
108570	7	< 0.1%
107655	4	< 0.1%
101270	8	< 0.1%
96880	5	< 0.1%

Auto

Heatmap
Table

	BEHANDELEND_SPECIALISME_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
BEHANDELEND_SPECIALISME_CD	1.000	0.218	0.008	0.013	-0.060	-0.054	-0.547	-0.467	0.049
ZORGPRODUCT_CD	0.218	1.000	-0.141	-0.150	-0.179	-0.211	-0.379	-0.404	0.025
AANTAL_PAT_PER_ZPD	0.008	-0.141	1.000	0.996	0.324	0.322	0.075	0.084	-0.301
AANTAL_SUBTRAJECT_PER_ZPD	0.013	-0.150	0.996	1.000	0.321	0.323	0.078	0.090	-0.304
AANTAL_PAT_PER_DIAG	-0.060	-0.179	0.324	0.321	1.000	0.988	0.322	0.304	0.026
AANTAL_SUBTRAJECT_PER_DIAG	-0.054	-0.211	0.322	0.323	0.988	1.000	0.338	0.335	0.035
AANTAL_PAT_PER_SPC	-0.547	-0.379	0.075	0.078	0.322	0.338	1.000	0.964	-0.012
AANTAL_SUBTRAJECT_PER_SPC	-0.467	-0.404	0.084	0.090	0.304	0.335	0.964	1.000	-0.015
GEMIDDELDE_VERKOOPPRIJS	0.049	0.025	-0.301	-0.304	0.026	0.035	-0.012	-0.015	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
0	1.0	2022-12-05	2022-12-01	2018-01-01	329	12	990029011	47	50	114	120	21981	24169	545.0
1	1.0	2022-12-05	2022-12-01	2018-01-01	329	15	990029012	265	272	1029	1075	21981	24169	1040.0
2	1.0	2022-12-05	2022-12-01	2018-01-01	329	14	990029012	19	19	97	97	21981	24169	1040.0
3	1.0	2022-12-05	2022-12-01	2018-01-01	329	07	990029011	676	690	1439	1500	21981	24169	545.0
4	1.0	2022-12-05	2022-12-01	2018-01-01	329	19	59899067	11	12	152	285	21981	24169	1440.0
5	1.0	2022-12-05	2022-12-01	2018-01-01	329	02	990029011	1375	1386	4872	4977	21981	24169	545.0
6	1.0	2022-12-05	2022-12-01	2018-01-01	329	05	990029010	256	261	1285	1346	21981	24169	1345.0
7	1.0	2022-12-05	2022-12-01	2018-01-01	329	13	990029002	6	6	156	157	21981	24169	205.0
8	1.0	2022-12-05	2022-12-01	2018-01-01	329	05	990029012	348	356	1285	1346	21981	24169	1040.0
9	1.0	2022-12-05	2022-12-01	2018-01-01	329	19	59899065	102	131	152	285	21981	24169	NaN

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
318334	1.0	2022-12-05	2022-12-01	2012-01-01	303	286	199299067	1	1	4316	4382	1487642	1939483	2185.0
318335	1.0	2022-12-05	2022-12-01	2012-01-01	303	113	119599007	1	1	14907	16118	1487642	1939483	NaN
318336	1.0	2022-12-05	2022-12-01	2014-01-01	313	839	20110030	1	1	449	1857	1037612	2062293	NaN
318337	1.0	2022-12-05	2022-12-01	2022-01-01	306	025	20110011	1	1	22	24	263062	315532	2770.0
318338	1.0	2022-12-05	2022-12-01	2014-01-01	313	722	131999063	1	1	160	204	1037612	2062293	1635.0
318339	1.0	2022-12-05	2022-12-01	2016-01-01	303	123	990356056	1	1	12120	14709	1332463	1832052	6140.0
318340	1.0	2022-12-05	2022-12-01	2022-01-01	306	038	149999007	2	2	8032	8920	263062	315532	NaN
318341	1.0	2022-12-05	2022-12-01	2022-01-01	306	086	179799017	1	1	18	23	263062	315532	NaN
318342	1.0	2022-12-05	2022-12-01	2022-01-01	306	030	20110077	1	1	23043	28125	263062	315532	NaN
318343	1.0	2022-12-05	2022-12-01	2016-01-01	303	298	131999176	1	1	1398	1891	1332463	1832052	2945.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample